CREATE proc [dbo].[SP_UDP_EMPLOYEES_update]      
 @EMP_ID int ,       
 @ACC_ID int ,      
 @EMP_FIRSTNAME nvarchar(100) ,     
 @EMP_LASTNAME nvarchar(100) ,    
 @EMP_ADDRESS nvarchar(300) ,     
 @EMP_PHONE nvarchar (12) ,      
 @EMP_STARTDATE dateTime ,     
 @EMP_LICENSE nvarchar(100) ,     
 @EMP_POSITION nvarchar(100),
 @EMP_COMMISSION int       
as      
begin      
update  [EMPLOYEES]      
set  [EMP_FIRSTNAME]=@EMP_FIRSTNAME ,      
[EMP_LASTNAME]=@EMP_LASTNAME ,  [EMP_ADDRESS]=@EMP_ADDRESS ,    
[EMP_PHONE]=@EMP_PHONE ,  [EMP_STARTDATE]=@EMP_STARTDATE ,     
[EMP_LICENSE]=@EMP_LICENSE ,  [EMP_POSITION]=@EMP_POSITION , [EMP_COMMISSION]=@EMP_COMMISSION      
where  [EMP_ID]= @EMP_ID  and ACC_ID=@ACC_ID    
     
end 